Pro SQL Database for Windows Azure, 2nd Edition shows how to create enterprise-level database deployments without the usual investment in datacenter and other infrastructure. Take advantage instead of Microsoft's worldwide backbone for cloud computing that delivers all the power of SQL Server in the form of the cloud-based SQL Database for Windows Azure. You can create and deploy a database in mere minutes that is accessible worldwide and takes advantage of SQL Database's high-availability features to protect your data while ensuring 99.9% uptime. SQL Azure is ideally suited for startups, who can benefit from instant access to a robust and secure web-accessible database platform for use in rapidly deploying new products to market. SQL Azure is also ideal for small and mid-sized businesses, giving them the same ability to deploy SQL Server as any large enterprise, but without the management overhead. Even large enterprises find SQL Azure useful in creating failover environments, development environments, extra capacity to handle surges in demand, and more.Pro SQL Database for Windows Azure covers the very latest in Microsoft's fast-moving, cloud platform, showing how to program and administer it in a variety of cloud computing scenarios. You'll learn to program SQL Azure from ASP.NET, from WinForms, and from SQL Reporting Services. You'll learn to manage the platform by planning for scalability, troubleshooting performance issues, and implementing strong security. You'll learn the unique aspects of SQL Azure such as sharding and federation support that combine to place SQL Azure a step above and ahead of the competiton. * Shows how to use SQL Azure from classic Windows applications, ASP.NET and Windows Communication Foundation * Covers management, performance, scalability, and troubleshooting * Addresses the all-important issue of securing your data * Helps you properly design for high-performance in a cloud environment * Helps you adopt the new Federations feature in SQL Azure What you'll learn * Create and manage SQL Database for Windows Azure databases * Access SQL Azure from WinForms, ASP.NET, Reporting Services, and more * Optimize database design for Azure's distributed cloud platform * Share data between databases using SQL Database's Data Synch Service * Secure data from intrusion and unauthorized access * Learn strategies for data migration and backup Who this book is for Pro SQL Database for Windows Azure, 2nd Edition is aimed at developers and database administrators desiring instant access to a fully-capable SQL Server database environment without the pain of sorting out and managing the physical infrastructure. Table of ContentsChapter 1: Getting Started with SQL Database Chapter 2: Design Considerations Chapter 3: Security Chapter 4: Data Migration and Backup Strategies Chapter 5: Programming with SQL Database Chapter 6: SQL Reporting Chapter 7: SQL Data Sync Chapter 8: Windows Azure and ASP.NET Chapter 9: Designing for High Performance Chapter 10: Federations Chapter 11: Performance Tuning Chapter 12: Windows Azure Mobile Services Appendix A: SQL Database Management Portal Appendix B: SQL Database Quick Reference

SQL Azure represents Microsoft's cloud-based delivery of its enterprise-caliber, SQL Server database management system (formerly under the code name Oslo). Pro SQL Azure introduces you to this new platform, showing you how to program and administer it in a variety of cloud computing scenarios. You'll learn to program SQL Azure from Silverlight, ASP.NET, WinForms, and from SQL Reporting Services. You'll also understand how to manage the platform by planning for scalability, troubleshooting performance issues, and implementing strong security. * Shows how to use SQL Azure from Silverlight, ASP.NET, and more* Covers management, scalability, and troubleshooting* Addresses the all-important issue of securing your dataWhat you'll learn* Create and manage SQL Azure Databases* Access SQL Azure from Silverlight, WinForms, ASP.NET, Reporting Services, and more* Optimize your distributed database design for scalability and performance* Partition your databases and write multithreaded queries for parallel execution* Understand how to take advantage of Microsoft's S+S strategy to save money and increase agility with hybrid cloud computing* Use ADO.NET and LINQ in .NET 4 with Visual Studio 2010* Pinpoint where SQL Azure makes things simpler than running on-premise databases* Understand when to apply new technologies to optimize performance when running your database in the cloudWho this book is for Pro SQL Azure is for DBAs and developers who want to use SQL Server in the cloud, and especially for those who want to go deeper and learn important strategies and techniques for effective cloud computing. Table of Contents* Getting Started with SQL Azure* SQL Azure Design Considerations* Setting up and Configuring your SQL Azure Environment* Security* Data Migration and Backup Strategy* Programming SQL Azure* Reporting Services* Using Entity Framework, REST, and ADO.NET Data Services with SQL Azure* Windows Azure and ASP.NET* Designing for High Performance* Synchronization Services* Performance Tuning* Appendix A-Resources* Appendix B-Supported Features

Collect and analyze sensor and usage data from Internet of Things applications with Microsoft Azure IoT Suite. Internet connectivity to everyday devices such as light bulbs, thermostats, and even voice-command devices such as Google Home and Amazon.com's Alexa is exploding. These connected devices and their respective applications generate large amounts of data that can be mined to enhance user-friendliness and make predictions about what a user might be likely to do next. Microsoft's Azure IoT Suite is a cloud-based platform that is ideal for collecting data from connected devices. You'll learn in this book about data acquisition and analysis, including real-time analysis. Real-world examples are provided to teach you to detect anomalous patterns in your data that might lead to business advantage. We live in a time when the amount of data being generated and stored is growing at an exponential rate. Understanding and getting real-time insight into these data is critical to business. IoT Solutions in Microsoft's Azure IoT Suite walks you through a complete, end-to-end journey of how to collect and store data from Internet-connected devices. You'll learn to analyze the data and to apply your results to solving real-world problems. Your customers will benefit from the increasingly capable and reliable applications that you'll be able to deploy to them. You and your business will benefit from the gains in insight and knowledge that can be applied to delight your customers and increase the value from their business. What You'll Learn Go through data generation, collection, and storage from sensors and devices, both relational and non-relational Understand, from end to end, Microsoft's analytic services and where they fit into the analytical ecosystem Look at the Internet of your things and find ways to discover and draw on the insights your data can provide Understand Microsoft's IoT technologies and services, and stitch them together for business insight and advantage Who This Book Is For Developers and architects who plan on delivering IoT solutions, data scientists who want to understand how to get better insights into their data, and anyone needing or wanting to do real-time analysis of data from the Internet of Things

Learn effective and scalable database design techniques in a SQL Server environment.Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of the design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, authors Louis Davidson, Kevin Kline, Scott Klein, and Kurt Windisch show how to 'get it right' in SQL Server database design and lay a solid groundwork for the future use of valuable business data. Solid foundation in best practices and relational theory Maximize SQL Server features to enhance security, performance, scalability Thorough treatment from conceptual design to an effective, physical implementation What you'll learn Develop conceptual models of client data using interviews and client documentation Normalize data models to enhance scalability and the long term use of valuable data Translate conceptual models into high-performing SQL Server databases Secure and protect the integrity of data as part of meeting regulatory requirements Take full advantage of new SQL Server features such as the spatial datatype, XML support, transparent data encryption, and more Create effective indexing to speed query performance Who this book is for

Pro SQL Server 2008 Relational Database Design and Implementation is designed for programmers of all types who want to use SQL Server 2008 to store data. Rookie database programmers will find a complete course on the fundamentals of database design that includes conceptual designs and physical implementation. Seasoned veterans will find many tips and tricks for implementing database systems that will be well worth the time invested in reading this book.

Prepare for Microsoft Exam 70-765-and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: * Implement SQL in Azure * Manage databases and instances * Manage storage This Microsoft Exam Ref: * Organizes its coverage by exam objectives * Features strategic, what-if scenarios to challenge you * Assumes you have working knowledge of SQL Server administration and maintenance, as well as Azure skills Provisioning SQL Databases About the Exam Exam 70-765 focuses on skills and knowledge for provisioning, upgrading, and configuring SQL Server; managing databases and files; and provisioning, migrating, and managing databases in the Microsoft Azure cloud. About Microsoft Certification Passing this exam as well as Exam 70-764: Administering a SQL Database Infrastructure earns you MCSA: SQL 2016 Database Administration certification, qualifying you for a position as a database administrator or infrastructure specialist. See full details at: microsoft.com/learning